<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>zxxhouse: com.zxx.sql.DataBaseHelper类参考</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />



</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">zxxhouse
   &#160;<span id="projectnumber">1.0</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- 制作者 Doxygen 1.7.6.1 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>首页</span></a></li>
      <li class="current"><a href="annotated.html"><span>类</span></a></li>
      <li><a href="files.html"><span>文件</span></a></li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>组合类型列表</span></a></li>
      <li><a href="classes.html"><span>组合类型索引</span></a></li>
      <li><a href="inherits.html"><span>类继承关系</span></a></li>
      <li><a href="functions.html"><span>组合类型成员</span></a></li>
    </ul>
  </div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><b>com</b>      </li>
      <li class="navelem"><b>zxx</b>      </li>
      <li class="navelem"><b>sql</b>      </li>
      <li class="navelem"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html">DataBaseHelper</a>      </li>
    </ul>
  </div>
</div>
<div class="header">
  <div class="summary">
<a href="#pub-methods">公有成员</a> &#124;
<a href="#pri-methods">私有成员</a>  </div>
  <div class="headertitle">
<div class="title">com.zxx.sql.DataBaseHelper类参考</div>  </div>
</div><!--header-->
<div class="contents">
<!-- doxytag: class="com::zxx::sql::DataBaseHelper" --><!-- doxytag: inherits="android::database::sqlite::SQLiteOpenHelper" -->
<p>直接操作数据库类，sqlman调用该类  
 <a href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#details">更多...</a></p>

<p>继承自SQLiteOpenHelper。</p>

<p><a href="classcom_1_1zxx_1_1sql_1_1_data_base_helper-members.html">所有成员的列表。</a></p>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-methods"></a>
公有成员</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a483a17681020106c4c5446ae3659ca58"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::onCreate" ref="a483a17681020106c4c5446ae3659ca58" args="(SQLiteDatabase db)" -->
void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a483a17681020106c4c5446ae3659ca58">onCreate</a> (SQLiteDatabase db)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">建立数据表 <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a142d88439400d7dcff3ca070cd0fca54"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::insertData" ref="a142d88439400d7dcff3ca070cd0fca54" args="(houseData data)" -->
long&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a142d88439400d7dcff3ca070cd0fca54">insertData</a> (<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> data)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">建立数据表 <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a1ba2df090cac74b2a3281f0df8d8b6ce"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byDepart" ref="a1ba2df090cac74b2a3281f0df8d8b6ce" args="(String departMent, int limitindex, int limitnum)" -->
ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1ba2df090cac74b2a3281f0df8d8b6ce">select_byDepart</a> (String departMent, int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">按小区选择 <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4d00facfe50abf683dc52b21f777a067">select_byTotalPricebelow100W</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">选取数据库中总价在100Ｗ下的房子  <a href="#a4d00facfe50abf683dc52b21f777a067"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a738880bd8d0083701bbbd655af857b3c">select_byTotalPriceabove200W</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">选取数据库中总价在200Ｗ上的房子  <a href="#a738880bd8d0083701bbbd655af857b3c"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#aac7ea38dc71810971006c13cc3af3f90">select_byTotalPricebetween100_200</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">选取数据库中总价在100Ｗ——200W之间的房子  <a href="#aac7ea38dc71810971006c13cc3af3f90"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a5a7ecb58ce31d571efa6232cdff0332a">select_byPmPricebelow1W</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">选取数据库中单价小于1W的房子  <a href="#a5a7ecb58ce31d571efa6232cdff0332a"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ae337350f3219c2a9a30488389cb30a07">select_byPmPriceabove2W</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">选取数据库中单价在2Ｗ上的房子  <a href="#ae337350f3219c2a9a30488389cb30a07"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a9a3df95a83eba8230a03bfcd91d62620">select_byPricebetween1w_2w</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">选取数据库中单价在1Ｗ——2W之间的房子  <a href="#a9a3df95a83eba8230a03bfcd91d62620"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">boolean&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a64cc784e2906df5e67508069246f91c7">selectRepeatData</a> (<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> data)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">查询数据库是不是有重复数据  <a href="#a64cc784e2906df5e67508069246f91c7"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1">getSortListRest</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取列表剩余项目  <a href="#ac07978f4e7858ba1fdc4ee3cf70b38c1"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4ad07dffcd6eafdcd227136f6d1bf6d8">getDepartmentRest</a> (String[] args)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取区域剩余项目  <a href="#a4ad07dffcd6eafdcd227136f6d1bf6d8"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8c36701e1a6550ae6e9c9fd212118cd2">getTotalPricebelow100W</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取总价格剩余项目(小于100W)  <a href="#a8c36701e1a6550ae6e9c9fd212118cd2"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1a573af5e5dc2e3da464db8306ac202f">getTotalPrice100W_200W</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取总价格剩余项目(100W_200W之间)  <a href="#a1a573af5e5dc2e3da464db8306ac202f"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac8d51264dab4db042d6fc81f31b7a67b">getTotalPriceabove200W</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取总价格剩余项目(大于200Ｗ)  <a href="#ac8d51264dab4db042d6fc81f31b7a67b"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a97a296a026ae1dffff131cdf5e3b5575">getHouseTypeRest</a> (String[] args)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取按房子类型的剩余屋子总数  <a href="#a97a296a026ae1dffff131cdf5e3b5575"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a09d0383cf37d1e8b86acb34b447e97b4">getZXTypeRest</a> (String[] args)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取按装修类型的房子剩余总数  <a href="#a09d0383cf37d1e8b86acb34b447e97b4"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8049b88898ba4ac2d5f419cd3acf3e92">getPmPriceBELOW1W</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取单价剩余项目(小于1W)  <a href="#a8049b88898ba4ac2d5f419cd3acf3e92"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ad9f82a031e22b1c73f1ee42bf39aa803">getPmPrice1W_2W</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取单价剩余项目(1W_2W之间)  <a href="#ad9f82a031e22b1c73f1ee42bf39aa803"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a83b37eb5a06585c21f6343622bcb19ed">getPmPriceabove2W</a> ()</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取单价剩余项目(大于2Ｗ)  <a href="#a83b37eb5a06585c21f6343622bcb19ed"></a><br/></td></tr>
<tr><td colspan="2"><h2><a name="pri-methods"></a>
私有成员</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1">selectSQL</a> (String sqlquery, String[] args)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取数据库按sql语句拼接后查询结果  <a href="#a244e424a6144e30e6fb02544ac12fef1"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43">getSQLCount</a> (String sqlquery, String[] args)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">获取数据库按sql语句拼接后查询的总列数  <a href="#ac5fa833c7831d807f81ac6044ccfeb43"></a><br/></td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>详细描述</h2>
<div class="textblock"><p>直接操作数据库类，sqlman调用该类 </p>
<dl class="author"><dt><b>作者:</b></dt><dd>Administrator </dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00021">21</a>行定义。</p>
</div><hr/><h2>成员函数文档</h2>
<a class="anchor" id="a4ad07dffcd6eafdcd227136f6d1bf6d8"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getDepartmentRest" ref="a4ad07dffcd6eafdcd227136f6d1bf6d8" args="(String[] args)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4ad07dffcd6eafdcd227136f6d1bf6d8">com.zxx.sql.DataBaseHelper.getDepartmentRest</a> </td>
          <td>(</td>
          <td class="paramtype">String[]&#160;</td>
          <td class="paramname"><em>args</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取区域剩余项目 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">args</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00312">312</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00277">com.zxx.sql.sqlMan.getdepartmentAllRow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="455,5,807,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4ad07dffcd6eafdcd227136f6d1bf6d8_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a18d6c85da0f0fd72cddd38bed00f6b83" title="com.zxx.sql.sqlMan.getdepartmentAllRow" alt="" coords="455,5,796,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a97a296a026ae1dffff131cdf5e3b5575"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getHouseTypeRest" ref="a97a296a026ae1dffff131cdf5e3b5575" args="(String[] args)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a97a296a026ae1dffff131cdf5e3b5575">com.zxx.sql.DataBaseHelper.getHouseTypeRest</a> </td>
          <td>(</td>
          <td class="paramtype">String[]&#160;</td>
          <td class="paramname"><em>args</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取按房子类型的剩余屋子总数 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">args</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00344">344</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00329">com.zxx.sql.sqlMan.getHouseTypeRow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="452,5,804,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a97a296a026ae1dffff131cdf5e3b5575_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a5e18d0bd4b1170a043a4b43f32f651f7" title="com.zxx.sql.sqlMan.getHouseTypeRow" alt="" coords="451,5,776,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ad9f82a031e22b1c73f1ee42bf39aa803"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getPmPrice1W_2W" ref="ad9f82a031e22b1c73f1ee42bf39aa803" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ad9f82a031e22b1c73f1ee42bf39aa803">com.zxx.sql.DataBaseHelper.getPmPrice1W_2W</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取单价剩余项目(1W_2W之间) </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00369">369</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00354">com.zxx.sql.sqlMan.getPmPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="455,5,807,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ad9f82a031e22b1c73f1ee42bf39aa803_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da" title="com.zxx.sql.sqlMan.getPmPriceAllrow" alt="" coords="453,5,768,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a83b37eb5a06585c21f6343622bcb19ed"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getPmPriceabove2W" ref="a83b37eb5a06585c21f6343622bcb19ed" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a83b37eb5a06585c21f6343622bcb19ed">com.zxx.sql.DataBaseHelper.getPmPriceabove2W</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取单价剩余项目(大于2Ｗ) </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00376">376</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00354">com.zxx.sql.sqlMan.getPmPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="468,5,820,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a83b37eb5a06585c21f6343622bcb19ed_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da" title="com.zxx.sql.sqlMan.getPmPriceAllrow" alt="" coords="467,5,781,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a8049b88898ba4ac2d5f419cd3acf3e92"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getPmPriceBELOW1W" ref="a8049b88898ba4ac2d5f419cd3acf3e92" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8049b88898ba4ac2d5f419cd3acf3e92">com.zxx.sql.DataBaseHelper.getPmPriceBELOW1W</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取单价剩余项目(小于1W) </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00362">362</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00354">com.zxx.sql.sqlMan.getPmPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="481,5,833,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8049b88898ba4ac2d5f419cd3acf3e92_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da" title="com.zxx.sql.sqlMan.getPmPriceAllrow" alt="" coords="480,5,795,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ac07978f4e7858ba1fdc4ee3cf70b38c1"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getSortListRest" ref="ac07978f4e7858ba1fdc4ee3cf70b38c1" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1">com.zxx.sql.DataBaseHelper.getSortListRest</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取列表剩余项目 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00303">303</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00277">com.zxx.sql.sqlMan.getdepartmentAllRow()</a>、<a class="el" href="sql_man_8java_source.html#l00354">com.zxx.sql.sqlMan.getPmPriceAllrow()</a>、<a class="el" href="sql_man_8java_source.html#l00269">com.zxx.sql.sqlMan.getSqlAllRow()</a>及<a class="el" href="sql_man_8java_source.html#l00292">com.zxx.sql.sqlMan.getTotalPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="423,5,775,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac07978f4e7858ba1fdc4ee3cf70b38c1_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a18d6c85da0f0fd72cddd38bed00f6b83" title="com.zxx.sql.sqlMan.getdepartmentAllRow" alt="" coords="423,5,764,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da" title="com.zxx.sql.sqlMan.getPmPriceAllrow" alt="" coords="436,61,751,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a4de4fb93998425200bce9ac7d8d94385" title="com.zxx.sql.sqlMan.getSqlAllRow" alt="" coords="453,117,733,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01" title="com.zxx.sql.sqlMan.getTotalPriceAllrow" alt="" coords="431,173,756,205"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ac5fa833c7831d807f81ac6044ccfeb43"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getSQLCount" ref="ac5fa833c7831d807f81ac6044ccfeb43" args="(String sqlquery, String[] args)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43">com.zxx.sql.DataBaseHelper.getSQLCount</a> </td>
          <td>(</td>
          <td class="paramtype">String&#160;</td>
          <td class="paramname"><em>sqlquery</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">String[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [private]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取数据库按sql语句拼接后查询的总列数 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">sqlquery</td><td>数据库拼接sql语句 </td></tr>
    <tr><td class="paramname">args</td><td>数据库拼接sql语句数组 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>列数 </dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00387">387</a>行定义。</p>

<p>参考自 <a class="el" href="_data_base_helper_8java_source.html#l00312">com.zxx.sql.DataBaseHelper.getDepartmentRest()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00344">com.zxx.sql.DataBaseHelper.getHouseTypeRest()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00369">com.zxx.sql.DataBaseHelper.getPmPrice1W_2W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00376">com.zxx.sql.DataBaseHelper.getPmPriceabove2W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00362">com.zxx.sql.DataBaseHelper.getPmPriceBELOW1W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00303">com.zxx.sql.DataBaseHelper.getSortListRest()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00327">com.zxx.sql.DataBaseHelper.getTotalPrice100W_200W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00334">com.zxx.sql.DataBaseHelper.getTotalPriceabove200W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00320">com.zxx.sql.DataBaseHelper.getTotalPricebelow100W()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00354">com.zxx.sql.DataBaseHelper.getZXTypeRest()</a>.</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac5fa833c7831d807f81ac6044ccfeb43_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac5fa833c7831d807f81ac6044ccfeb43_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac5fa833c7831d807f81ac6044ccfeb43_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac5fa833c7831d807f81ac6044ccfeb43_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4ad07dffcd6eafdcd227136f6d1bf6d8" title="获取区域剩余项目" alt="" coords="435,5,832,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a97a296a026ae1dffff131cdf5e3b5575" title="获取按房子类型的剩余屋子总数" alt="" coords="435,453,832,485"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ad9f82a031e22b1c73f1ee42bf39aa803" title="获取单价剩余项目(1W_2W之间)" alt="" coords="433,117,833,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a83b37eb5a06585c21f6343622bcb19ed" title="获取单价剩余项目(大于2Ｗ)" alt="" coords="428,173,839,205"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8049b88898ba4ac2d5f419cd3acf3e92" title="获取单价剩余项目(小于1W)" alt="" coords="420,229,847,261"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1" title="获取列表剩余项目" alt="" coords="451,61,816,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1a573af5e5dc2e3da464db8306ac202f" title="获取总价格剩余项目(100W_200W之间)" alt="" coords="408,285,859,317"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac8d51264dab4db042d6fc81f31b7a67b" title="获取总价格剩余项目(大于200Ｗ)" alt="" coords="412,341,855,373"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8c36701e1a6550ae6e9c9fd212118cd2" title="获取总价格剩余项目(小于100W)" alt="" coords="413,397,853,429"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a09d0383cf37d1e8b86acb34b447e97b4" title="获取按装修类型的房子剩余总数" alt="" coords="449,509,817,541"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a18d6c85da0f0fd72cddd38bed00f6b83" title="com.zxx.sql.sqlMan.getdepartmentAllRow" alt="" coords="908,5,1249,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a5e18d0bd4b1170a043a4b43f32f651f7" title="com.zxx.sql.sqlMan.getHouseTypeRow" alt="" coords="916,453,1241,485"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da" title="com.zxx.sql.sqlMan.getPmPriceAllrow" alt="" coords="921,145,1236,177"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a4de4fb93998425200bce9ac7d8d94385" title="com.zxx.sql.sqlMan.getSqlAllRow" alt="" coords="939,61,1219,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01" title="com.zxx.sql.sqlMan.getTotalPriceAllrow" alt="" coords="916,313,1241,345"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#adb9f43d7a23c7db4adc2978b96c7feda" title="com.zxx.sql.sqlMan.getZXTypeRow" alt="" coords="931,509,1227,541"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a1a573af5e5dc2e3da464db8306ac202f"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getTotalPrice100W_200W" ref="a1a573af5e5dc2e3da464db8306ac202f" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1a573af5e5dc2e3da464db8306ac202f">com.zxx.sql.DataBaseHelper.getTotalPrice100W_200W</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取总价格剩余项目(100W_200W之间) </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00327">327</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00292">com.zxx.sql.sqlMan.getTotalPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="505,5,857,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a1a573af5e5dc2e3da464db8306ac202f_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01" title="com.zxx.sql.sqlMan.getTotalPriceAllrow" alt="" coords="505,5,831,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ac8d51264dab4db042d6fc81f31b7a67b"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getTotalPriceabove200W" ref="ac8d51264dab4db042d6fc81f31b7a67b" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac8d51264dab4db042d6fc81f31b7a67b">com.zxx.sql.DataBaseHelper.getTotalPriceabove200W</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取总价格剩余项目(大于200Ｗ) </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00334">334</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00292">com.zxx.sql.sqlMan.getTotalPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="497,5,849,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ac8d51264dab4db042d6fc81f31b7a67b_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01" title="com.zxx.sql.sqlMan.getTotalPriceAllrow" alt="" coords="497,5,823,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a8c36701e1a6550ae6e9c9fd212118cd2"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getTotalPricebelow100W" ref="a8c36701e1a6550ae6e9c9fd212118cd2" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8c36701e1a6550ae6e9c9fd212118cd2">com.zxx.sql.DataBaseHelper.getTotalPricebelow100W</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取总价格剩余项目(小于100W) </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00320">320</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00292">com.zxx.sql.sqlMan.getTotalPriceAllrow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="497,5,849,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a8c36701e1a6550ae6e9c9fd212118cd2_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01" title="com.zxx.sql.sqlMan.getTotalPriceAllrow" alt="" coords="497,5,823,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a09d0383cf37d1e8b86acb34b447e97b4"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::getZXTypeRest" ref="a09d0383cf37d1e8b86acb34b447e97b4" args="(String[] args)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a09d0383cf37d1e8b86acb34b447e97b4">com.zxx.sql.DataBaseHelper.getZXTypeRest</a> </td>
          <td>(</td>
          <td class="paramtype">String[]&#160;</td>
          <td class="paramname"><em>args</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取按装修类型的房子剩余总数 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">args</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00354">354</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00387">com.zxx.sql.DataBaseHelper.getSQLCount()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00341">com.zxx.sql.sqlMan.getZXTypeRow()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="425,5,777,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a09d0383cf37d1e8b86acb34b447e97b4_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#adb9f43d7a23c7db4adc2978b96c7feda" title="com.zxx.sql.sqlMan.getZXTypeRow" alt="" coords="425,5,721,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ae337350f3219c2a9a30488389cb30a07"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byPmPriceabove2W" ref="ae337350f3219c2a9a30488389cb30a07" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ae337350f3219c2a9a30488389cb30a07">com.zxx.sql.DataBaseHelper.select_byPmPriceabove2W</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>选取数据库中单价在2Ｗ上的房子 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">limitindex　限制开始</td><td></td></tr>
    <tr><td class="paramname">limitnum</td><td>限制选取数量 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00174">174</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00254">com.zxx.sql.DataBaseHelper.selectSQL()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00193">com.zxx.sql.sqlMan.selectSQLByPmPrice()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="515,5,843,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_ae337350f3219c2a9a30488389cb30a07_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#aaba0ff9f406a4804784aed9e4f97a811" title="com.zxx.sql.sqlMan.selectSQLByPmPrice" alt="" coords="516,5,857,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a5a7ecb58ce31d571efa6232cdff0332a"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byPmPricebelow1W" ref="a5a7ecb58ce31d571efa6232cdff0332a" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a5a7ecb58ce31d571efa6232cdff0332a">com.zxx.sql.DataBaseHelper.select_byPmPricebelow1W</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>选取数据库中单价小于1W的房子 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">limitindex　限制开始</td><td></td></tr>
    <tr><td class="paramname">limitnum</td><td>限制选取数量 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00163">163</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00254">com.zxx.sql.DataBaseHelper.selectSQL()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00193">com.zxx.sql.sqlMan.selectSQLByPmPrice()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="512,5,840,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a5a7ecb58ce31d571efa6232cdff0332a_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#aaba0ff9f406a4804784aed9e4f97a811" title="com.zxx.sql.sqlMan.selectSQLByPmPrice" alt="" coords="513,5,855,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a9a3df95a83eba8230a03bfcd91d62620"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byPricebetween1w_2w" ref="a9a3df95a83eba8230a03bfcd91d62620" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a9a3df95a83eba8230a03bfcd91d62620">com.zxx.sql.DataBaseHelper.select_byPricebetween1w_2w</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>选取数据库中单价在1Ｗ——2W之间的房子 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">limitindex　限制开始</td><td></td></tr>
    <tr><td class="paramname">limitnum</td><td>限制选取数量 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00185">185</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00254">com.zxx.sql.DataBaseHelper.selectSQL()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00193">com.zxx.sql.sqlMan.selectSQLByPmPrice()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="536,5,864,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a9a3df95a83eba8230a03bfcd91d62620_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#aaba0ff9f406a4804784aed9e4f97a811" title="com.zxx.sql.sqlMan.selectSQLByPmPrice" alt="" coords="537,5,879,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a738880bd8d0083701bbbd655af857b3c"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byTotalPriceabove200W" ref="a738880bd8d0083701bbbd655af857b3c" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a738880bd8d0083701bbbd655af857b3c">com.zxx.sql.DataBaseHelper.select_byTotalPriceabove200W</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>选取数据库中总价在200Ｗ上的房子 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">limitindex　限制开始</td><td></td></tr>
    <tr><td class="paramname">limitnum</td><td>限制选取数量 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00130">130</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00254">com.zxx.sql.DataBaseHelper.selectSQL()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00149">com.zxx.sql.sqlMan.selectSQLByTotalPrice()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="547,5,875,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a738880bd8d0083701bbbd655af857b3c_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a08637e16cd1a288c8bb8ce20ca83e8dc" title="com.zxx.sql.sqlMan.selectSQLByTotalPrice" alt="" coords="548,5,903,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a4d00facfe50abf683dc52b21f777a067"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byTotalPricebelow100W" ref="a4d00facfe50abf683dc52b21f777a067" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4d00facfe50abf683dc52b21f777a067">com.zxx.sql.DataBaseHelper.select_byTotalPricebelow100W</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>选取数据库中总价在100Ｗ下的房子 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">limitindex　限制开始</td><td></td></tr>
    <tr><td class="paramname">limitnum</td><td>限制选取数量 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00120">120</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00254">com.zxx.sql.DataBaseHelper.selectSQL()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00149">com.zxx.sql.sqlMan.selectSQLByTotalPrice()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="544,5,872,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a4d00facfe50abf683dc52b21f777a067_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a08637e16cd1a288c8bb8ce20ca83e8dc" title="com.zxx.sql.sqlMan.selectSQLByTotalPrice" alt="" coords="545,5,900,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="aac7ea38dc71810971006c13cc3af3f90"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::select_byTotalPricebetween100_200" ref="aac7ea38dc71810971006c13cc3af3f90" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#aac7ea38dc71810971006c13cc3af3f90">com.zxx.sql.DataBaseHelper.select_byTotalPricebetween100_200</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>选取数据库中总价在100Ｗ——200W之间的房子 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">limitindex　限制开始</td><td></td></tr>
    <tr><td class="paramname">limitnum</td><td>限制选取数量 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00141">141</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00254">com.zxx.sql.DataBaseHelper.selectSQL()</a>.</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00149">com.zxx.sql.sqlMan.selectSQLByTotalPrice()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_cgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="587,5,915,37"/></map>
</div>
</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_aac7ea38dc71810971006c13cc3af3f90_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a08637e16cd1a288c8bb8ce20ca83e8dc" title="com.zxx.sql.sqlMan.selectSQLByTotalPrice" alt="" coords="588,5,943,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a64cc784e2906df5e67508069246f91c7"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::selectRepeatData" ref="a64cc784e2906df5e67508069246f91c7" args="(houseData data)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">boolean <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a64cc784e2906df5e67508069246f91c7">com.zxx.sql.DataBaseHelper.selectRepeatData</a> </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&#160;</td>
          <td class="paramname"><em>data</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>查询数据库是不是有重复数据 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">data</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00289">289</a>行定义。</p>

<p>参考自 <a class="el" href="sql_man_8java_source.html#l00066">com.zxx.sql.sqlMan.insertData()</a>.</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a64cc784e2906df5e67508069246f91c7_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a64cc784e2906df5e67508069246f91c7_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a64cc784e2906df5e67508069246f91c7_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a64cc784e2906df5e67508069246f91c7_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ade630bd22dc7fdafbcb853061b6912f1" title="com.zxx.sql.sqlMan.insertData" alt="" coords="440,5,696,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a244e424a6144e30e6fb02544ac12fef1"></a><!-- doxytag: member="com::zxx::sql::DataBaseHelper::selectSQL" ref="a244e424a6144e30e6fb02544ac12fef1" args="(String sqlquery, String[] args)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1">com.zxx.sql.DataBaseHelper.selectSQL</a> </td>
          <td>(</td>
          <td class="paramtype">String&#160;</td>
          <td class="paramname"><em>sqlquery</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">String[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [private]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>获取数据库按sql语句拼接后查询结果 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">sqlquery</td><td>数据库拼接sql语句 </td></tr>
    <tr><td class="paramname">args</td><td>数据库拼接sql语句数组 </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>结果集列表 </dd></dl>

<p>在文件<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a>第<a class="el" href="_data_base_helper_8java_source.html#l00254">254</a>行定义。</p>

<p>参考自 <a class="el" href="_data_base_helper_8java_source.html#l00105">com.zxx.sql.DataBaseHelper.select_byDepart()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00174">com.zxx.sql.DataBaseHelper.select_byPmPriceabove2W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00163">com.zxx.sql.DataBaseHelper.select_byPmPricebelow1W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00185">com.zxx.sql.DataBaseHelper.select_byPricebetween1w_2w()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00130">com.zxx.sql.DataBaseHelper.select_byTotalPriceabove200W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00120">com.zxx.sql.DataBaseHelper.select_byTotalPricebelow100W()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00141">com.zxx.sql.DataBaseHelper.select_byTotalPricebetween100_200()</a>.</p>

<p><div class="dynheader">
这是这个函数的调用图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a244e424a6144e30e6fb02544ac12fef1_icgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1_data_base_helper_a244e424a6144e30e6fb02544ac12fef1_icgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a244e424a6144e30e6fb02544ac12fef1_icgraph" id="classcom_1_1zxx_1_1sql_1_1_data_base_helper_a244e424a6144e30e6fb02544ac12fef1_icgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1ba2df090cac74b2a3281f0df8d8b6ce" title="按小区选择" alt="" coords="461,5,835,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ae337350f3219c2a9a30488389cb30a07" title="选取数据库中单价在2Ｗ上的房子" alt="" coords="419,61,877,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a5a7ecb58ce31d571efa6232cdff0332a" title="选取数据库中单价小于1W的房子" alt="" coords="419,117,877,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a9a3df95a83eba8230a03bfcd91d62620" title="选取数据库中单价在1Ｗ——2W之间的房子" alt="" coords="408,173,888,205"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a738880bd8d0083701bbbd655af857b3c" title="选取数据库中总价在200Ｗ上的房子" alt="" coords="403,229,893,261"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4d00facfe50abf683dc52b21f777a067" title="选取数据库中总价在100Ｗ下的房子" alt="" coords="403,285,893,317"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#aac7ea38dc71810971006c13cc3af3f90" title="选取数据库中总价在100Ｗ——200W之间的房子" alt="" coords="381,341,915,373"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51e1619f15f11234a9b2f2e5d45138d9" title="com.zxx.sql.sqlMan.selectSQLByDepart" alt="" coords="977,5,1305,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#aaba0ff9f406a4804784aed9e4f97a811" title="com.zxx.sql.sqlMan.selectSQLByPmPrice" alt="" coords="971,117,1312,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a08637e16cd1a288c8bb8ce20ca83e8dc" title="com.zxx.sql.sqlMan.selectSQLByTotalPrice" alt="" coords="964,285,1319,317"/></map>
</div>
</p>

</div>
</div>
<hr/>该类的文档由以下文件生成：<ul>
<li>src/com/zxx/sql/<a class="el" href="_data_base_helper_8java_source.html">DataBaseHelper.java</a></li>
</ul>
</div><!-- contents -->


<hr class="footer"/><address class="footer"><small>
Generated at 2015年二月4日 星期三 18:11:10 for zxxhouse by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.6.1
</small></address>

</body>
</html>
